You are here:

DateDiff

Returns the difference between two date/time values based on an interval type.

Syntax

DateDiff("IntervalType", "FromDateTime", "ToDateTime")

Arguments

Argument	Description
IntervalType	Time interval type.
FromDateTime	Any date/time expression. See Date/time format examples for valid formats.
ToDateTime	Any date/time expression. See Date/time format examples for valid formats.

Interval types

QA Wizard Pro counts interval types using the following methods:

y is the same as d (days).
w is the difference in days divided by seven, excluding fractions.
ww counts the number of weeks starting with Sunday. The from date is not counted and the to date is only counted if it is a Sunday.
q counts the number of quarter starts. For example, January 1, April 1, July 1, and October 1.
Parts of years, quarters, and months more specific than the interval type are excluded before the calculation is performed. For example, the difference between December 31, 2015 11:59:59 PM and January 1, 2016 12:00:00 AM measured in years, quarters, or months all return 1, even though the actual elapsed time is one second.

Return value

Value	Description
Value	Difference between two date/time values based on the interval.

Example

numDays = DateDiff("d", "3 Feb 1962", Now())